CREATE TABLE regions
(
    id CHAR PRIMARY KEY,
    name VARCHAR(20) UNIQUE NOT NULL
);

CREATE TABLE countries
(
    id DECIMAL(3) PRIMARY KEY,
    name VARCHAR(50) UNIQUE NOT NULL,
    region CHAR NOT NULL,
    area REAL,
    population REAL,
    gdp REAL,
    FOREIGN KEY(region) REFERENCES regions(id)
);